﻿CREATE PROCEDURE [dbo].[authors_get_id]
    @firstName nvarchar(256),
    @lastName nvarchar(256),
    @middleName nvarchar(256)
AS
    DECLARE @authorId int = 0
    SELECT @authorId = Authors.AuthorId
    FROM Authors
    WHERE Authors.FirstName = @firstName
        AND Authors.LastName = @lastName
        AND Authors.MiddleName = @middleName
RETURN @authorId
